The ComboBox Control

The ComboBox object is an application prompt that allows multiple items to be displayed in an area of the application, one of which may be selected. Items may be sorted and/or selected as required by the needs of the application.

To use a ComboBox, VBA script is used to populate and manage items displayed in the box or the ComboBox prompt can contain the values itself by entering them in the List property.

The ColumnSet property group is used to add ColumnSets (the structure or template to create a column) and set specific properties for each Column within a ColumnSet. For example, you can add 3 columns in the ColumnSet1 group, and in the first column, use CheckBoxes, in the second Column, use Text (to label the checkbox) and the 3rd column, use Memo so the user can enter notes in this column. The ColumnSet: Columns: [Column#]: (Style) property enables you to select the format of the item in each column. The values are: (Text), CheckBox, Decimal, Image, and Memo.

To stylize the appearance of a column, see ListOptions.

The ListOptions property group provides many features for how the a list of items are presented and selected. Some of the key features are:

  • AllowRoll - allows the user to reverse the order to see items that may be at the end of a list.
  • AltRow - enables different shading for every other row
  • CheckBox - Stylizes the checkbox if this was the "(Style)" chosen for a ColumnSet: Column: [Column#].
  • Image - Sets the spacing if this was the "(Style)" chosen for a ColumnSet: Column: [Column#].
  • RowStyle - Sets the background color and forecolor text for a row
  • SelectRow - Sets the style for a selected row in the list. "(Default)" means it uses the Theme values.
  • SortMode - Sets how the items in a list are sorted -- Ascending, Descending or None.
  • Style - Sets whether the dropdown menu will display the list as full screen (List), display as a list with the Search function enabled, or the usual drop down menu size (Standard).

 

For property descriptions, see Graphical Control Properties.